Close message Due to maintenance between 17:00 to 21:00 on Tuesday 14th May 2024, Scootle website may face disruption in service. We apologise for any inconvenience caused.

Search results

Listed under:  Mathematics  >  Statistics and probability  >  Data representation  >  Spreadsheets
Online

Turtles: impact of climate change on Flatback turtle populations

The lesson follows an inquiry process in which students use a dataset to answer relevant questions about the turtle population. They consider how to analyse and display the data in order to effectively examine the impact of rising global temperatures on flatback turtle populations.

Online

Protecting dugongs

The Western Australian Marine Science Institution has been collecting data about dugongs off the coast of the Kimberley in Northern WA. We have been provided with the raw data from its sightings trips. In this project students will learn how dugong sightings are conducted, and develop the data-science skills needed to make ...

Online

COVID 19 Demystified course

At the end of this course, learners should be able to better understand the science and numbers behindCOVID-19 and the SARS-CoV-2 virus that causes it. They should be able to discuss the pandemic with confidence, giving substantiated viewpoints on matters such as public policy with a willingness to accept other viewpoints. ...

Online

Creating my own spreadsheet to convert binary to decimal

A spreadsheet can be used to do calculations quickly using formulas. How can we make a spreadsheet that converts a binary number to a decimal number? This lesson provides some guidance and Excel files for student and teacher use.

Online

Spreadsheets come alive

In this lesson sequence use the ‘Odds and evens’ problem as a springboard. Students construct interactive spreadsheets designed to address particular needs. This lesson also demonstrates an approach to programming known as rapid application development (RAD).

Online

A spreadsheet's secret weapon

In this lesson sequence, students learn to use pivot tables which have been described as the most powerful tool within spreadsheets.

Online

Weather forecast from the stratosphere

This lesson sequence is designed to introduce students to data analysis using a spreadsheet such as MS Excel. The project is based on a real world problem and a real data set from a weather balloon launched in Australia earlier this year. The project consists of 5 lessons of variable length, each with a different focus. ...

Online

Who wants to be a millionaire?

This lesson sequence uses the well-known wheat/rice and chessboard problem as students use spreadsheets to simulate iteration and to solve problems.

Online

Seeing the wood for the trees

In this lesson sequence students summarise data using advanced filtering and grouping techniques, for example pivot tables in spreadsheets and aggregation functions in databases.

Online

Hot or not?

This lesson sequence focuses on the incremental or Agile approach to development and encourages students to follow the evolution of a temperature conversion tool for a Food Technology teacher. It uses an Excel spreadsheet application as the prototyping tool.

Online

Data driven innovation

This is a unit for Year 9 from the Scope and sequence resources from the DT Hub. The topic of data is organised into four key elements. Use this flow of activities to plan and assess students against the relevant achievement standards. Students examine ways data from individuals and connected technologies is used to inform ...

Online

Organise, visualise and analyse

This is a unit for Year 10 from the Scope and sequence resources from the DT Hub. The topic of data is organised into four key elements. Use this flow of activities to plan and assess students against the relevant achievement standards. Students use tools to organise data and make sense of complex data to identify patterns ...

Online

Get connected

This is a unit for Year 7 from the Scope and sequence resources from the DT Hub. The topic of digital systems is organised into four key elements. Use this flow of activities to plan and assess students against the relevant achievement standards. Students develop an understanding of the properties of networked systems and ...

Online

Data: Controlled and secured

This is a unit for Year 10 from the Scope and sequence resources from the DT Hub. The topic of digital systems is organised into four key elements. Use this flow of activities to plan and assess students against the relevant achievement standards. Students explore how data can be secured through various methods such as ...

Online

Computer chatter 1: Networks and data transmission

In this lesson sequence students relate the concept of transportation systems to help them develop an understanding of the properties of networked systems and the underlying techniques used to transmit and validate data.

Text

ACARA sample assessment task: years 9-10

This resource provides strategies for assessing students' ability to interpret, process, analyse and represent data using spreadsheets, pivot tables, plotting data and scripting activities. A link to a data set from a koala hospital provides extensive data for students to use. The resource includes maps, graphs and charts, ...

Text

Asunda review: STEM integration

This article explores the benefits of an interdisciplinary STEM program in the quest for providing students with a holistic approach to problem-solving that reflects real-world practice. This is supported by a conceptual framework that comprises four constructs: systems thinking, situation learning theory, constructivism ...

Video

DTiF in conversation with Kevin Bradley and Cassandra Arkinstall from Save the Bilby Fund – Using Digital Technologies to help save bilbies

Kevin Bradley, CEO of Save the Bilby Fund, and Cassandra Arkinstall, a researcher and volunteer at Save the Bilby Fund explain how important digital technologies are in the campaign to save the bilby from extinction. The video explains how digital systems are used to collect and visualise data and help eradicate threats ...

Text

Digital Technolodgies in Focus: external evaluation - findings on a page

This PDF is a one-page summary of the key findings of an external evalation of the Digital Technologies in Focus project in Australia’s most disadvantaged schools.

Text

Newsletter – December 2019

This newsletter from the Digital Technologies in Focus project includes information about schools' projects, information for parents and teachers, the Australian Curriculum, and useful resources.